SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrAsignaturasGenericas
AS
SELECT     idAsignaturaGenerica AS ID, Descripcion, Mnemo, Baja
FROM         dbo.tb_AsignaturasGenericas
WHERE     (Baja = 'N')
GO
GRANT SELECT ON  [dbo].[vwrAsignaturasGenericas] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrAsignaturasGenericas] TO [Juntas]
GRANT SELECT ON  [dbo].[vwrAsignaturasGenericas] TO [public]
GRANT SELECT ON  [dbo].[vwrAsignaturasGenericas] TO [SoloVer]
GO
